EasyASP Wizards

Here is a tutorial on using the Program's ASP Wizards

---

This section will walk you through creating a contact us page

1. Create a database with one table and at least these fields: (Please note that you can create any type of field that you want. The one's below are only examples. This script uses 3 fields)
   
   • One field for the Name
   • One field for the Company
   • One field for an Email Address
2. Place the new database in your ODBC driver list by creating an entry in the File DSN section
3. Open the Contact Form Wizard
4. Click on the Create Html Form button
5. Fill out the following information: (Again examples are placed in to help clarify)
   • Action Name: The name you will call the ASP page we will create later
   • Field 1: Name this field something similar to the database name like FrmName or something like that
   • Field 2: Name this field something similar to the database name like FrmCompany or something like that
   • Field 3: Name this field something similar to the database name like FrmEmail or something like that
   • Submit: This is the text shown on the submit button
   • Reset: This is the text shown on the Reset button
6. Click the next button and the html form page will be created and placed in a new file
7. Now the ASP page wizard will show up.
8. Fill in the following information as follows:
   • Database DSN: This is the ODBC drivername that you created earlier for the database
   • Table Name: This is the name of the table you created in the database
   • First Form Element: This is the name of the form field you created in the last section like FrmName
   • 2nd Form Element: This is the name of the form field you created in the last section like FrmCompany
   • 3rd Form Element: This is the name of the form field you created in the last section like FrmEmail
9. Click the Finish button and it will create the ASP code page for the Contact Wizard.
10. Now save the files. You could save the html page as contact.html and the asp page should be saved as the name you gave it in the HTML Action section of the first wizard part. for instance process.asp
11. Now just place the files in your web server and you should be ready to go. You can then edit the pages to fit your needs like adding more entries and creating a better looking contact page.

Section 2: The Database Query Wizard

Below you will find the steps nessasary to create a quick database query using ASP.

1. Create a database with one table and at least these fields: (Please note that you can create any type of field that you want. The one's below are only examples. This script uses 3 fields)
   
   • One field for the First Data item. In my case i'm checking names so FirstName is my first field
   • One field for the Second Data item. In my case i'm checking names so LastName is my Second field
   • One field for the Combination Data item. This field will be a combination of the top 2 fields. For instance if firstname and lastname were my first two fields then this field would be called firstlast and inside it would be the first and last name of a person. For instance if Firstname = Eric and LastName = Banker than firstlast would = EricBanker
2. Place the Database in your ODBC Administrator on the File DSN tab
3. Next open up the Database Query Wizard and select the Create HTML Page button
4. Here you will answer the following questions:
   • Action Name: This is the name of the ASP page you will create
   • Field 1: This is the corresponding name to your first Database item. Something like FrmFirstName or something like that
   • Field 2: This is the corresponding name to your Second Database item. Something like FrmLastName or something like that
   • Submit: This is the text shown on the Submit Button
   • Reset: This is the text shown on the Reset Button
5. Click the next button and the html page will be created in a new window
6. Now the ASP Page will pop up
7. Fill in the following information:
   • ODBC Driver Name: This is the name that you called the Database in the ODBC File DSN section
   • Table Name: This is the name of the table you created to store your data
   • CheckField: This is the entry in the database that you created that allows you to check if it's in there. This is a combination of the First and Second Database fields. Like a primary key. (Note: This is not the best way to do this but it does work. I have found other ways to do this check and this is not the best way and adds redundancy to the database. I'll leave it an excersize for the user to find the better ways to do this)
   • HTML Field 1: This is what you called the first Html Field
   • HTML Field 2: This is what you called the Second Html Field
   • Variable 1: This is another variable created for the check process. Name it anything you like. I usually call it something similar to the form field. For instance IFirst for FirstName
   • Variable 2: This is another variable created for the check process. Name it anything you like. I usually call it something similar to the form field. For instace ILast for LastName
8. Now click the Finish button and the ASP page will be created.
9. Save the files as an HTML and ASP page. Make the HTML form page something like Query.html and the ASP page something like Process.asp, remember that you must name the ASP file the same thing you called it in the action section of the HTML page
10. Place the files on the web server and put some data in to test with and you should be good to go.
11. You can then edit the files to make them look and act the way you want them to. It should be easy to see how you would add fields to the output. Simply grab that Database Column name and place it in the retrieve code then in the output section as shown.

Section 3: The Login Wizard

Below you will find the steps nessasary to create a secure login page for your web site

1. Create a database that contains one table and the following fields:
   • Name Field: This would normally be the username field
   • Password Field: This would normally be the Password Field
2. Place the database in the ODBC administrator under the File DSN tab
3. Open the Login Wizard
4. Click on the Create HTML and ASP Code button
5. Fill in the information as follows:
   • ODBC Driver Name: The name you called the database in the ODBC Administrator
   • Table Name: The name of the table that you created
   • Session Variable: This is what you will call the session varaible. It makes sure users only have to log in once
   • Database Fields Section
   • Name Field: This is the actual field name you created in the database
   • Password Field: This is the actual field name you created in the database
   • Action Name: This is a page that the script will take the user to if they are accepted and validated.
   • Form Name: This is the name you want to give the HTML form
   • Form Fields Section
   • Name Field: The name you want to give the HTML Form field, usually similar to the database name like FrmUserId or something like that
   • Password Field: The name you want to give the HTML form field, usually similar to the database name like FrmPassword or something like that
   • Submit: The text shown on the submit button
   • Reset: The text shown on the reset button
6. Click the insert button and it will create a new page with the asp and html code within it.
7. Save the file something you want like auth.asp or something like that
8. At the top of each page that you want to be protected place the following code:
   < !--#INCLUDE FILE = "passwordcodepage.asp" -- >

9. Please note that all protected pages must be saved as ASP pages and include the
   < %@ LANGUAGE="VBSCRIPT" % >
   tag at the top of the page